Elements and Performance Criteria
- Identify the required data and sources
- Identify the required organisational data, according to the enterprise’s knowledge management strategy
- Identify the subject areas, according to the business processes and the required enterprise data
- Explore the operational data, define the warehouse sources, and record the outcomes
- Develop the warehouse source specifications, according to the existing data tables and files
- Determine warehouse operational steps and processes
- Design and develop warehouse features
- Design and develop the warehouse user interface, according to the principles of user interface design
- Develop and implement the warehouse security strategy, according to the enterprise’s security plan
- Identify dimension tables and fact tables, according to the required enterprise data
- 3.4 Develop the warehouse information catalogue, according to the enterprise's knowledge management strategy
- Test and implement the data warehouse
- Test data the warehouse against the business requirements, to ensure that iterations meet the business objectives
- Recommend changes to business processes, to ensure compatibility with the data warehouse and the knowledge management strategy
- Implement the data warehouse
- Establish an ongoing maintenance schedule to keep the system efficient
- Benchmark and document the performance level of the data warehouse
- Finalise work processes